import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class aaa {

	public static void main(String[] args){
		try{
			
			String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:/netdesk/accDb/caipiao_fl.accdb";
			//String url = "jdbc:odbc:cp_fl";
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn = DriverManager.getConnection(url,"","");
			System.out.println(conn);
			Statement sta = conn.createStatement();
			ResultSet resu = sta.executeQuery("select * from doubleColor");
			if(resu.next()){
				System.out.println(resu.getString("red_1"));
			}
			System.out.println("exit");
			}catch(Exception e){
				e.printStackTrace();
			}
	}
}
